Profile listings

Dataset statistics

Number of variables	18
Number of observations	500
Missing cells	1104
Missing cells (%)	12.3%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	70.4 KiB
Average record size in memory	144.3 B

Variable types

Numeric	11
Text	2
Unsupported	2
Categorical	2
DateTime	1

Alerts

`id` is highly overall correlated with `host_id`	High correlation
`host_id` is highly overall correlated with `id` and 1 other fields	High correlation
`latitude` is highly overall correlated with `longitude` and 1 other fields	High correlation
`longitude` is highly overall correlated with `latitude` and 1 other fields	High correlation
`number_of_reviews` is highly overall correlated with `reviews_per_month` and 1 other fields	High correlation
`reviews_per_month` is highly overall correlated with `number_of_reviews` and 1 other fields	High correlation
`number_of_reviews_ltm` is highly overall correlated with `number_of_reviews` and 1 other fields	High correlation
`neighbourhood` is highly overall correlated with `host_id` and 3 other fields	High correlation
`room_type` is highly overall correlated with `neighbourhood`	High correlation
`neighbourhood_group` has 500 (100.0%) missing values	Missing
`last_review` has 52 (10.4%) missing values	Missing
`reviews_per_month` has 52 (10.4%) missing values	Missing
`license` has 500 (100.0%) missing values	Missing
`host_id` is highly skewed (γ1 = 22.05768788)	Skewed
`id` has unique values	Unique
`neighbourhood_group` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`license` is an unsupported type, check if it needs cleaning or further analysis	Unsupported
`number_of_reviews` has 52 (10.4%) zeros	Zeros
`availability_365` has 55 (11.0%) zeros	Zeros
`number_of_reviews_ltm` has 166 (33.2%) zeros	Zeros

Reproduction

Analysis started	2023-11-01 11:27:45.668738
Analysis finished	2023-11-01 11:28:32.377626
Duration	46.71 seconds
Software version	ydata-profiling vv4.6.1
Download configuration	config.json

id
Real number (ℝ)

HIGH CORRELATION UNIQUE

Distinct	500
Distinct (%)	100.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	537761.78

Minimum	17878
Maximum	942218
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	17878
5-th percentile	89891.45
Q1	286396.25
median	521684
Q3	829032
95-th percentile	919868.05
Maximum	942218
Range	924340
Interquartile range (IQR)	542635.75

Descriptive statistics

Standard deviation	286024.48
Coefficient of variation (CV)	0.53187951
Kurtosis	-1.4203727
Mean	537761.78
Median Absolute Deviation (MAD)	261642
Skewness	-0.078948901
Sum	2.6888089 × 10⁸
Variance	8.1810001 × 10¹⁰
Monotonicity	Strictly increasing

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
17878	1	0.2%
758632	1	0.2%
769674	1	0.2%
768172	1	0.2%
765614	1	0.2%
765255	1	0.2%
764769	1	0.2%
764534	1	0.2%
764205	1	0.2%
762988	1	0.2%
Other values (490)	490	98.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
17878	1	0.2%
25026	1	0.2%
35764	1	0.2%
48305	1	0.2%
48901	1	0.2%
49179	1	0.2%
51703	1	0.2%
53533	1	0.2%
60718	1	0.2%
64795	1	0.2%

Value	Count	Frequency (%)
942218	1	0.2%
941735	1	0.2%
940749	1	0.2%
937388	1	0.2%
935162	1	0.2%
935090	1	0.2%
935028	1	0.2%
932270	1	0.2%
931638	1	0.2%
930736	1	0.2%

name
Text

Distinct	421
Distinct (%)	84.2%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	83
Median length	74
Mean length	64.97
Min length	41

Characters and Unicode

Total characters	32485
Distinct characters	55
Distinct categories	7 ?
Distinct scripts	2 ?
Distinct blocks	3 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	379 ?
Unique (%)	75.8%

Sample

1st row	Condo in Rio de Janeiro · ★4.70 · 2 bedrooms · 2 beds · 1 bath
2nd row	Rental unit in Rio de Janeiro · ★4.71 · 1 bedroom · 1 bed · 1 bath
3rd row	Loft in Rio de Janeiro · ★4.90 · 1 bedroom · 1 bed · 1.5 baths
4th row	Rental unit in Ipanema · ★4.74 · 6 bedrooms · 7 beds · 7 baths
5th row	Rental unit in Rio · ★4.37 · 4 bedrooms · 5 beds · 3 baths

Value	Count	Frequency (%)
·	1897	23.3%
1	793	9.8%
in	500	6.1%
rio	470	5.8%
de	440	5.4%
janeiro	440	5.4%
rental	384	4.7%
unit	384	4.7%
2	330	4.1%
bedroom	311	3.8%
Other values (138)	2183	26.8%

Most occurring characters

Value	Count	Frequency (%)
	7635	23.5%
e	2442	7.5%
o	2036	6.3%
·	1897	5.8%
i	1858	5.7%
n	1771	5.5%
d	1529	4.7%
a	1516	4.7%
b	1480	4.6%
t	1362	4.2%
Other values (45)	8959	27.6%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	17837	54.9%
Space Separator	7635	23.5%
Decimal Number	2741	8.4%
Other Punctuation	2382	7.3%
Uppercase Letter	1474	4.5%
Other Symbol	413	1.3%
Dash Punctuation	3	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	2442	13.7%
o	2036	11.4%
i	1858	10.4%
n	1771	9.9%
d	1529	8.6%
a	1516	8.5%
b	1480	8.3%
t	1362	7.6%
r	1030	5.8%
s	747	4.2%
Other values (15)	2066	11.6%

Uppercase Letter

Value	Count	Frequency (%)
R	854	57.9%
J	441	29.9%
H	53	3.6%
C	41	2.8%
S	35	2.4%
L	18	1.2%
T	8	0.5%
G	8	0.5%
B	5	0.3%
I	5	0.3%
Other values (4)	6	0.4%

Decimal Number

Value	Count	Frequency (%)
1	887	32.4%
4	480	17.5%
2	394	14.4%
5	200	7.3%
3	178	6.5%
7	153	5.6%
8	152	5.5%
6	103	3.8%
9	99	3.6%
0	95	3.5%

Other Punctuation

Value	Count	Frequency (%)
·	1897	79.6%
.	484	20.3%
/	1	< 0.1%

Space Separator

Value	Count	Frequency (%)
	7635	100.0%

Other Symbol

Value	Count	Frequency (%)
★	413	100.0%

Dash Punctuation

Value	Count	Frequency (%)
-	3	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	19311	59.4%
Common	13174	40.6%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	2442	12.6%
o	2036	10.5%
i	1858	9.6%
n	1771	9.2%
d	1529	7.9%
a	1516	7.9%
b	1480	7.7%
t	1362	7.1%
r	1030	5.3%
R	854	4.4%
Other values (29)	3433	17.8%

Common

Value	Count	Frequency (%)
	7635	58.0%
·	1897	14.4%
1	887	6.7%
.	484	3.7%
4	480	3.6%
★	413	3.1%
2	394	3.0%
5	200	1.5%
3	178	1.4%
7	153	1.2%
Other values (6)	453	3.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	30172	92.9%
None	1900	5.8%
Misc Symbols	413	1.3%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
	7635	25.3%
e	2442	8.1%
o	2036	6.7%
i	1858	6.2%
n	1771	5.9%
d	1529	5.1%
a	1516	5.0%
b	1480	4.9%
t	1362	4.5%
r	1030	3.4%
Other values (41)	7513	24.9%

None

Value	Count	Frequency (%)
·	1897	99.8%
á	2	0.1%
ç	1	0.1%

Misc Symbols

Value	Count	Frequency (%)
★	413	100.0%

host_id
Real number (ℝ)

HIGH CORRELATION SKEWED

Distinct	378
Distinct (%)	75.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3103244.4

Minimum	64036
Maximum	3.8005921 × 10⁸
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	64036
5-th percentile	327674.8
Q1	856145
median	1916069
Q3	3910941
95-th percentile	4907879.5
Maximum	3.8005921 × 10⁸
Range	3.7999518 × 10⁸
Interquartile range (IQR)	3054796

Descriptive statistics

Standard deviation	16968570
Coefficient of variation (CV)	5.4680094
Kurtosis	490.95491
Mean	3103244.4
Median Absolute Deviation (MAD)	1283561.5
Skewness	22.057688
Sum	1.5516222 × 10⁹
Variance	2.8793235 × 10¹⁴
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4307081	17	3.4%
792218	8	1.6%
1429181	7	1.4%
1603206	5	1.0%
1648634	5	1.0%
449677	5	1.0%
2694627	4	0.8%
406989	4	0.8%
474221	4	0.8%
4005407	3	0.6%
Other values (368)	438	87.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
64036	1	0.2%
68997	1	0.2%
70933	2	0.4%
93005	1	0.2%
102840	1	0.2%
110002	1	0.2%
132230	1	0.2%
144943	1	0.2%
149407	1	0.2%
153691	1	0.2%

Value	Count	Frequency (%)
380059214	1	0.2%
9709135	1	0.2%
7506316	1	0.2%
6416134	1	0.2%
6005451	1	0.2%
5092388	1	0.2%
5060612	1	0.2%
5020460	1	0.2%
5006415	1	0.2%
5000563	1	0.2%

host_name
Text

Distinct	303
Distinct (%)	60.6%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Length

Max length	24
Median length	18
Mean length	7.182
Min length	3

Characters and Unicode

Total characters	3591
Distinct characters	67
Distinct categories	9 ?
Distinct scripts	3 ?
Distinct blocks	4 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	210 ?
Unique (%)	42.0%

Sample

1st row	Matthias
2nd row	Viviane
3rd row	Patricia Miranda & Paulo
4th row	Goitaca
5th row	Marcio

Value	Count	Frequency (%)
	19	3.0%
nereu	17	2.7%
a	17	2.7%
maria	14	2.2%
e	10	1.6%
renata	8	1.3%
ricardo	8	1.3%
levy	8	1.3%
casa	8	1.3%
monica	7	1.1%
Other values (311)	519	81.7%

Most occurring characters

Value	Count	Frequency (%)
a	550	15.3%
e	314	8.7%
i	309	8.6%
r	225	6.3%
o	220	6.1%
n	208	5.8%
l	198	5.5%
	138	3.8%
s	124	3.5%
u	117	3.3%
Other values (57)	1188	33.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	2806	78.1%
Uppercase Letter	611	17.0%
Space Separator	138	3.8%
Other Punctuation	18	0.5%
Decimal Number	8	0.2%
Nonspacing Mark	4	0.1%
Other Symbol	4	0.1%
Open Punctuation	1	< 0.1%
Close Punctuation	1	< 0.1%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	550	19.6%
e	314	11.2%
i	309	11.0%
r	225	8.0%
o	220	7.8%
n	208	7.4%
l	198	7.1%
s	124	4.4%
u	117	4.2%
t	99	3.5%
Other values (21)	442	15.8%

Uppercase Letter

Value	Count	Frequency (%)
M	63	10.3%
A	63	10.3%
R	57	9.3%
C	53	8.7%
L	46	7.5%
S	36	5.9%
J	33	5.4%
E	31	5.1%
G	31	5.1%
N	30	4.9%
Other values (15)	168	27.5%

Other Punctuation

Value	Count	Frequency (%)
&	11	61.1%
/	5	27.8%
,	1	5.6%
'	1	5.6%

Decimal Number

Value	Count	Frequency (%)
4	4	50.0%
8	4	50.0%

Space Separator

Value	Count	Frequency (%)
	138	100.0%

Nonspacing Mark

Value	Count	Frequency (%)
️	4	100.0%

Other Symbol

Value	Count	Frequency (%)
❤	4	100.0%

Open Punctuation

Value	Count	Frequency (%)
(	1	100.0%

Close Punctuation

Value	Count	Frequency (%)
)	1	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	3417	95.2%
Common	170	4.7%
Inherited	4	0.1%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	550	16.1%
e	314	9.2%
i	309	9.0%
r	225	6.6%
o	220	6.4%
n	208	6.1%
l	198	5.8%
s	124	3.6%
u	117	3.4%
t	99	2.9%
Other values (46)	1053	30.8%

Common

Value	Count	Frequency (%)
	138	81.2%
&	11	6.5%
/	5	2.9%
4	4	2.4%
❤	4	2.4%
8	4	2.4%
,	1	0.6%
(	1	0.6%
'	1	0.6%
)	1	0.6%

Inherited

Value	Count	Frequency (%)
️	4	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	3555	99.0%
None	28	0.8%
VS	4	0.1%
Dingbats	4	0.1%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	550	15.5%
e	314	8.8%
i	309	8.7%
r	225	6.3%
o	220	6.2%
n	208	5.9%
l	198	5.6%
	138	3.9%
s	124	3.5%
u	117	3.3%
Other values (47)	1152	32.4%

None

Value	Count	Frequency (%)
é	11	39.3%
á	6	21.4%
ã	4	14.3%
É	3	10.7%
ç	1	3.6%
â	1	3.6%
í	1	3.6%
ê	1	3.6%

VS

Value	Count	Frequency (%)
️	4	100.0%

Dingbats

Value	Count	Frequency (%)
❤	4	100.0%

neighbourhood_group
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	500
Missing (%)	100.0%
Memory size	4.0 KiB

neighbourhood
Categorical

HIGH CORRELATION

Distinct	41
Distinct (%)	8.2%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Copacabana	191
Ipanema	70
Santa Teresa	46
Botafogo	26
Leblon	25
Other values (36)	142

Length

Max length	24
Median length	17
Mean length	9.336
Min length	3

Characters and Unicode

Total characters	4668
Distinct characters	45
Distinct categories	3 ?
Distinct scripts	2 ?
Distinct blocks	2 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	14 ?
Unique (%)	2.8%

Sample

1st row	Copacabana
2nd row	Copacabana
3rd row	Copacabana
4th row	Ipanema
5th row	Copacabana

Common Values

Value	Count	Frequency (%)
Copacabana	191	38.2%
Ipanema	70	14.0%
Santa Teresa	46	9.2%
Botafogo	26	5.2%
Leblon	25	5.0%
Barra da Tijuca	22	4.4%
Leme	14	2.8%
Laranjeiras	10	2.0%
Gávea	9	1.8%
Centro	8	1.6%
Other values (31)	79	15.8%

Length

Histogram of lengths of the category

Value	Count	Frequency (%)
copacabana	191	30.3%
ipanema	70	11.1%
santa	46	7.3%
teresa	46	7.3%
da	27	4.3%
botafogo	26	4.1%
tijuca	26	4.1%
leblon	25	4.0%
barra	22	3.5%
leme	14	2.2%
Other values (45)	137	21.7%

Most occurring characters

Value	Count	Frequency (%)
a	1316	28.2%
n	388	8.3%
o	364	7.8%
e	284	6.1%
p	266	5.7%
c	240	5.1%
b	216	4.6%
C	209	4.5%
r	166	3.6%
	130	2.8%
Other values (35)	1089	23.3%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	3939	84.4%
Uppercase Letter	599	12.8%
Space Separator	130	2.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
a	1316	33.4%
n	388	9.9%
o	364	9.2%
e	284	7.2%
p	266	6.8%
c	240	6.1%
b	216	5.5%
r	166	4.2%
m	109	2.8%
t	105	2.7%
Other values (17)	485	12.3%

Uppercase Letter

Value	Count	Frequency (%)
C	209	34.9%
T	77	12.9%
I	72	12.0%
B	62	10.4%
S	53	8.8%
L	53	8.8%
G	16	2.7%
V	13	2.2%
J	12	2.0%
F	8	1.3%
Other values (7)	24	4.0%

Space Separator

Value	Count	Frequency (%)
	130	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	4538	97.2%
Common	130	2.8%

Most frequent character per script

Latin

Value	Count	Frequency (%)
a	1316	29.0%
n	388	8.6%
o	364	8.0%
e	284	6.3%
p	266	5.9%
c	240	5.3%
b	216	4.8%
C	209	4.6%
r	166	3.7%
m	109	2.4%
Other values (34)	980	21.6%

Common

Value	Count	Frequency (%)
	130	100.0%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	4628	99.1%
None	40	0.9%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
a	1316	28.4%
n	388	8.4%
o	364	7.9%
e	284	6.1%
p	266	5.7%
c	240	5.2%
b	216	4.7%
C	209	4.5%
r	166	3.6%
	130	2.8%
Other values (29)	1049	22.7%

None

Value	Count	Frequency (%)
á	21	52.5%
â	6	15.0%
ó	5	12.5%
ã	4	10.0%
ú	2	5.0%
ç	2	5.0%

latitude
Real number (ℝ)

HIGH CORRELATION

Distinct	464
Distinct (%)	92.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-22.965474

Minimum	-23.03154
Maximum	-22.84008
Zeros	0
Zeros (%)	0.0%
Negative	500
Negative (%)	100.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	-23.03154
5-th percentile	-23.002984
Q1	-22.982948
median	-22.97355
Q3	-22.955032
95-th percentile	-22.915426
Maximum	-22.84008
Range	0.19146
Interquartile range (IQR)	0.027915

Descriptive statistics

Standard deviation	0.027651223
Coefficient of variation (CV)	-0.0012040345
Kurtosis	1.768627
Mean	-22.965474
Median Absolute Deviation (MAD)	0.0106
Skewness	1.120192
Sum	-11482.737
Variance	0.00076459011
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-22.97995	3	0.6%
-22.98253	3	0.6%
-22.96633	3	0.6%
-22.98069	3	0.6%
-22.98251	3	0.6%
-22.96102	2	0.4%
-22.98434	2	0.4%
-22.9814015	2	0.4%
-22.98114	2	0.4%
-22.98632	2	0.4%
Other values (454)	475	95.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-23.03154	1	0.2%
-23.01805	1	0.2%
-23.0165	1	0.2%
-23.01545	1	0.2%
-23.01524	1	0.2%
-23.01522	1	0.2%
-23.01469	1	0.2%
-23.01344	1	0.2%
-23.01147	1	0.2%
-23.01124	1	0.2%

Value	Count	Frequency (%)
-22.84008	1	0.2%
-22.84087	1	0.2%
-22.84208	1	0.2%
-22.89141	1	0.2%
-22.89315	1	0.2%
-22.8957679	1	0.2%
-22.90022	1	0.2%
-22.90544	1	0.2%
-22.90559	1	0.2%
-22.90574	1	0.2%

longitude
Real number (ℝ)

HIGH CORRELATION

Distinct	467
Distinct (%)	93.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-43.211477

Minimum	-43.61203
Maximum	-43.16542
Zeros	0
Zeros (%)	0.0%
Negative	500
Negative (%)	100.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	-43.61203
5-th percentile	-43.364044
Q1	-43.206338
median	-43.191465
Q3	-43.184337
95-th percentile	-43.174899
Maximum	-43.16542
Range	0.44661
Interquartile range (IQR)	0.02200038

Descriptive statistics

Standard deviation	0.058951986
Coefficient of variation (CV)	-0.0013642669
Kurtosis	10.401737
Mean	-43.211477
Median Absolute Deviation (MAD)	0.009125
Skewness	-3.0903823
Sum	-21605.738
Variance	0.0034753366
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-43.19277	3	0.6%
-43.19054	3	0.6%
-43.17754	3	0.6%
-43.19024	3	0.6%
-43.18969	3	0.6%
-43.19215	3	0.6%
-43.18863	2	0.4%
-43.19411917	2	0.4%
-43.17257	2	0.4%
-43.18703	2	0.4%
Other values (457)	474	94.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-43.61203	1	0.2%
-43.49074	1	0.2%
-43.47979	1	0.2%
-43.47437	1	0.2%
-43.45943	1	0.2%
-43.45271	1	0.2%
-43.44626	1	0.2%
-43.44438	1	0.2%
-43.43045	1	0.2%
-43.42651	1	0.2%

Value	Count	Frequency (%)
-43.16542	1	0.2%
-43.16666	1	0.2%
-43.166691	1	0.2%
-43.16717	1	0.2%
-43.16751	1	0.2%
-43.1676	1	0.2%
-43.168194	1	0.2%
-43.16858	1	0.2%
-43.16868	1	0.2%
-43.17022	1	0.2%

room_type
Categorical

HIGH CORRELATION

Distinct	3
Distinct (%)	0.6%
Missing	0
Missing (%)	0.0%
Memory size	4.0 KiB

Entire home/apt	339
Private room	160
Shared room	1

Length

Max length	15
Median length	15
Mean length	14.032
Min length	11

Characters and Unicode

Total characters	7016
Distinct characters	17
Distinct categories	4 ?
Distinct scripts	2 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	1 ?
Unique (%)	0.2%

Sample

1st row	Entire home/apt
2nd row	Entire home/apt
3rd row	Entire home/apt
4th row	Entire home/apt
5th row	Entire home/apt

Common Values

Value	Count	Frequency (%)
Entire home/apt	339	67.8%
Private room	160	32.0%
Shared room	1	0.2%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
entire	339	33.9%
home/apt	339	33.9%
room	161	16.1%
private	160	16.0%
shared	1	0.1%

Most occurring characters

Value	Count	Frequency (%)
e	839	12.0%
t	838	11.9%
o	661	9.4%
r	661	9.4%
a	500	7.1%
	500	7.1%
m	500	7.1%
i	499	7.1%
h	340	4.8%
p	339	4.8%
Other values (7)	1339	19.1%

Most occurring categories

Value	Count	Frequency (%)
Lowercase Letter	5677	80.9%
Space Separator	500	7.1%
Uppercase Letter	500	7.1%
Other Punctuation	339	4.8%

Most frequent character per category

Lowercase Letter

Value	Count	Frequency (%)
e	839	14.8%
t	838	14.8%
o	661	11.6%
r	661	11.6%
a	500	8.8%
m	500	8.8%
i	499	8.8%
h	340	6.0%
p	339	6.0%
n	339	6.0%
Other values (2)	161	2.8%

Uppercase Letter

Value	Count	Frequency (%)
E	339	67.8%
P	160	32.0%
S	1	0.2%

Space Separator

Value	Count	Frequency (%)
	500	100.0%

Other Punctuation

Value	Count	Frequency (%)
/	339	100.0%

Most occurring scripts

Value	Count	Frequency (%)
Latin	6177	88.0%
Common	839	12.0%

Most frequent character per script

Latin

Value	Count	Frequency (%)
e	839	13.6%
t	838	13.6%
o	661	10.7%
r	661	10.7%
a	500	8.1%
m	500	8.1%
i	499	8.1%
h	340	5.5%
p	339	5.5%
E	339	5.5%
Other values (5)	661	10.7%

Common

Value	Count	Frequency (%)
	500	59.6%
/	339	40.4%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	7016	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
e	839	12.0%
t	838	11.9%
o	661	9.4%
r	661	9.4%
a	500	7.1%
	500	7.1%
m	500	7.1%
i	499	7.1%
h	340	4.8%
p	339	4.8%
Other values (7)	1339	19.1%

price
Real number (ℝ)

Distinct	277
Distinct (%)	55.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	595.614

Minimum	57
Maximum	25000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	57
5-th percentile	119.95
Q1	194
median	298
Q3	542
95-th percentile	1716
Maximum	25000
Range	24943
Interquartile range (IQR)	348

Descriptive statistics

Standard deviation	1413.581
Coefficient of variation (CV)	2.3733173
Kurtosis	185.2703
Mean	595.614
Median Absolute Deviation (MAD)	133.5
Skewness	11.866752
Sum	297807
Variance	1998211.3
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
200	15	3.0%
250	14	2.8%
180	13	2.6%
300	11	2.2%
500	10	2.0%
130	9	1.8%
400	9	1.8%
220	8	1.6%
150	8	1.6%
140	7	1.4%
Other values (267)	396	79.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
57	1	0.2%
59	1	0.2%
60	2	0.4%
65	1	0.2%
70	1	0.2%
75	1	0.2%
77	1	0.2%
79	1	0.2%
90	1	0.2%
97	1	0.2%

Value	Count	Frequency (%)
25000	1	0.2%
10000	1	0.2%
8607	1	0.2%
7381	1	0.2%
5874	1	0.2%
4904	2	0.4%
4000	1	0.2%
3464	1	0.2%
3448	1	0.2%
3000	1	0.2%

minimum_nights
Real number (ℝ)

Distinct	18
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.934

Minimum	1
Maximum	90
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	2
median	3
Q3	4
95-th percentile	7
Maximum	90
Range	89
Interquartile range (IQR)	2

Descriptive statistics

Standard deviation	6.4330718
Coefficient of variation (CV)	1.6352496
Kurtosis	88.592348
Mean	3.934
Median Absolute Deviation (MAD)	1
Skewness	8.3461493
Sum	1967
Variance	41.384413
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=18)

Value	Count	Frequency (%)
2	135	27.0%
3	128	25.6%
1	80	16.0%
4	59	11.8%
5	47	9.4%
7	19	3.8%
6	9	1.8%
10	4	0.8%
14	3	0.6%
28	3	0.6%
Other values (8)	13	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	80	16.0%
2	135	27.0%
3	128	25.6%
4	59	11.8%
5	47	9.4%
6	9	1.8%
7	19	3.8%
8	2	0.4%
10	4	0.8%
14	3	0.6%

Value	Count	Frequency (%)
90	1	0.2%
60	2	0.4%
30	3	0.6%
28	3	0.6%
22	1	0.2%
21	1	0.2%
20	1	0.2%
15	2	0.4%
14	3	0.6%
10	4	0.8%

number_of_reviews
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	189
Distinct (%)	37.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	72.968

Minimum	0
Maximum	611
Zeros	52
Zeros (%)	10.4%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	5
median	32
Q3	106
95-th percentile	277.25
Maximum	611
Range	611
Interquartile range (IQR)	101

Descriptive statistics

Standard deviation	98.80293
Coefficient of variation (CV)	1.3540584
Kurtosis	5.5996932
Mean	72.968
Median Absolute Deviation (MAD)	31
Skewness	2.1711543
Sum	36484
Variance	9762.019
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	52	10.4%
1	25	5.0%
4	16	3.2%
8	12	2.4%
3	12	2.4%
6	11	2.2%
5	11	2.2%
11	10	2.0%
2	10	2.0%
9	8	1.6%
Other values (179)	333	66.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	52	10.4%
1	25	5.0%
2	10	2.0%
3	12	2.4%
4	16	3.2%
5	11	2.2%
6	11	2.2%
7	3	0.6%
8	12	2.4%
9	8	1.6%

Value	Count	Frequency (%)
611	1	0.2%
577	1	0.2%
540	1	0.2%
458	1	0.2%
446	1	0.2%
424	1	0.2%
421	1	0.2%
420	1	0.2%
416	1	0.2%
403	1	0.2%

last_review
Date

MISSING

Distinct	222
Distinct (%)	49.6%
Missing	52
Missing (%)	10.4%
Memory size	4.0 KiB

Minimum	2012-02-21 00:00:00
Maximum	2023-09-22 00:00:00

Histogram

Histogram with fixed size bins (bins=50)

reviews_per_month
Real number (ℝ)

HIGH CORRELATION MISSING

Distinct	164
Distinct (%)	36.6%
Missing	52
Missing (%)	10.4%
Infinite	0
Infinite (%)	0.0%
Mean	0.63069196

Minimum	0.01
Maximum	4.58
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	0.01
5-th percentile	0.02
Q1	0.1
median	0.34
Q3	0.8925
95-th percentile	2.129
Maximum	4.58
Range	4.57
Interquartile range (IQR)	0.7925

Descriptive statistics

Standard deviation	0.74072745
Coefficient of variation (CV)	1.1744679
Kurtosis	4.5132997
Mean	0.63069196
Median Absolute Deviation (MAD)	0.29
Skewness	1.9551403
Sum	282.55
Variance	0.54867715
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0.02	19	3.8%
0.04	17	3.4%
0.01	15	3.0%
0.06	13	2.6%
0.03	11	2.2%
0.09	11	2.2%
0.1	10	2.0%
0.05	10	2.0%
0.08	9	1.8%
0.14	8	1.6%
Other values (154)	325	65.0%
(Missing)	52	10.4%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0.01	15	3.0%
0.02	19	3.8%
0.03	11	2.2%
0.04	17	3.4%
0.05	10	2.0%
0.06	13	2.6%
0.07	4	0.8%
0.08	9	1.8%
0.09	11	2.2%
0.1	10	2.0%

Value	Count	Frequency (%)
4.58	1	0.2%
4.07	1	0.2%
3.79	1	0.2%
3.29	1	0.2%
3.25	1	0.2%
3.14	1	0.2%
3.1	1	0.2%
3.06	1	0.2%
3.04	1	0.2%
2.98	1	0.2%

calculated_host_listings_count
Real number (ℝ)

Distinct	19
Distinct (%)	3.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	5.28

Minimum	1
Maximum	121
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	2
Q3	4
95-th percentile	14.2
Maximum	121
Range	120
Interquartile range (IQR)	3

Descriptive statistics

Standard deviation	12.09803
Coefficient of variation (CV)	2.2912935
Kurtosis	38.842185
Mean	5.28
Median Absolute Deviation (MAD)	1
Skewness	5.5727373
Sum	2640
Variance	146.36232
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=19)

Value	Count	Frequency (%)
1	206	41.2%
2	88	17.6%
3	57	11.4%
4	32	6.4%
5	22	4.4%
6	20	4.0%
8	19	3.8%
52	17	3.4%
7	10	2.0%
10	10	2.0%
Other values (9)	19	3.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	206	41.2%
2	88	17.6%
3	57	11.4%
4	32	6.4%
5	22	4.4%
6	20	4.0%
7	10	2.0%
8	19	3.8%
9	6	1.2%
10	10	2.0%

Value	Count	Frequency (%)
121	2	0.4%
52	17	3.4%
34	3	0.6%
28	1	0.2%
20	1	0.2%
18	1	0.2%
14	1	0.2%
12	1	0.2%
11	3	0.6%
10	10	2.0%

availability_365
Real number (ℝ)

ZEROS

Distinct	228
Distinct (%)	45.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	210.116

Minimum	0
Maximum	365
Zeros	55
Zeros (%)	11.0%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	92.75
median	224
Q3	343.25
95-th percentile	365
Maximum	365
Range	365
Interquartile range (IQR)	250.5

Descriptive statistics

Standard deviation	130.73427
Coefficient of variation (CV)	0.62220045
Kurtosis	-1.3839054
Mean	210.116
Median Absolute Deviation (MAD)	123.5
Skewness	-0.28353473
Sum	105058
Variance	17091.449
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	55	11.0%
365	46	9.2%
363	13	2.6%
364	9	1.8%
362	9	1.8%
359	7	1.4%
327	5	1.0%
349	5	1.0%
328	4	0.8%
286	4	0.8%
Other values (218)	343	68.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	55	11.0%
2	1	0.2%
3	1	0.2%
5	2	0.4%
6	1	0.2%
7	1	0.2%
15	1	0.2%
19	1	0.2%
20	2	0.4%
21	1	0.2%

Value	Count	Frequency (%)
365	46	9.2%
364	9	1.8%
363	13	2.6%
362	9	1.8%
361	4	0.8%
360	4	0.8%
359	7	1.4%
358	3	0.6%
357	3	0.6%
356	1	0.2%

number_of_reviews_ltm
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	50
Distinct (%)	10.0%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	8.51

Minimum	0
Maximum	68
Zeros	166
Zeros (%)	33.2%
Negative	0
Negative (%)	0.0%
Memory size	4.0 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	3
Q3	12.25
95-th percentile	34.05
Maximum	68
Range	68
Interquartile range (IQR)	12.25

Descriptive statistics

Standard deviation	12.166592
Coefficient of variation (CV)	1.4296817
Kurtosis	3.840377
Mean	8.51
Median Absolute Deviation (MAD)	3
Skewness	1.9305516
Sum	4255
Variance	148.02595
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	166	33.2%
1	40	8.0%
2	35	7.0%
4	24	4.8%
3	21	4.2%
6	15	3.0%
8	14	2.8%
7	13	2.6%
10	12	2.4%
5	12	2.4%
Other values (40)	148	29.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	166	33.2%
1	40	8.0%
2	35	7.0%
3	21	4.2%
4	24	4.8%
5	12	2.4%
6	15	3.0%
7	13	2.6%
8	14	2.8%
9	10	2.0%

Value	Count	Frequency (%)
68	1	0.2%
62	1	0.2%
61	1	0.2%
60	1	0.2%
58	1	0.2%
50	1	0.2%
48	2	0.4%
45	1	0.2%
43	3	0.6%
40	2	0.4%

license
Unsupported

MISSING REJECTED UNSUPPORTED

Missing	500
Missing (%)	100.0%
Memory size	4.0 KiB

Auto

Heatmap
Table

	id	host_id	latitude	longitude	price	minimum_nights	number_of_reviews	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	neighbourhood	room_type
id	1.000	0.750	0.039	-0.031	0.064	0.039	-0.167	-0.104	0.018	-0.003	-0.139	0.051	0.000
host_id	0.750	1.000	0.060	-0.041	0.047	-0.063	-0.178	-0.115	-0.051	0.047	-0.146	0.502	0.000
latitude	0.039	0.060	1.000	0.541	-0.297	-0.105	-0.190	-0.165	-0.115	-0.018	-0.171	0.787	0.233
longitude	-0.031	-0.041	0.541	1.000	-0.259	0.087	0.150	0.048	-0.003	-0.042	0.122	0.841	0.000
price	0.064	0.047	-0.297	-0.259	1.000	0.042	-0.225	-0.163	-0.144	0.217	-0.235	0.000	0.000
minimum_nights	0.039	-0.063	-0.105	0.087	0.042	1.000	-0.030	-0.122	-0.104	-0.097	-0.058	0.000	0.000
number_of_reviews	-0.167	-0.178	-0.190	0.150	-0.225	-0.030	1.000	0.966	0.104	-0.214	0.815	0.000	0.161
reviews_per_month	-0.104	-0.115	-0.165	0.048	-0.163	-0.122	0.966	1.000	0.043	-0.277	0.795	0.148	0.139
calculated_host_listings_count	0.018	-0.051	-0.115	-0.003	-0.144	-0.104	0.104	0.043	1.000	0.091	0.084	0.057	0.000
availability_365	-0.003	0.047	-0.018	-0.042	0.217	-0.097	-0.214	-0.277	0.091	1.000	-0.159	0.000	0.185
number_of_reviews_ltm	-0.139	-0.146	-0.171	0.122	-0.235	-0.058	0.815	0.795	0.084	-0.159	1.000	0.000	0.177
neighbourhood	0.051	0.502	0.787	0.841	0.000	0.000	0.000	0.148	0.057	0.000	0.000	1.000	0.731
room_type	0.000	0.000	0.233	0.000	0.000	0.000	0.161	0.139	0.000	0.185	0.177	0.731	1.000

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

The correlation heatmap measures nullity correlation: how strongly the presence or absence of one variable affects the presence of another.

First rows
Last rows

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	license
0	17878	Condo in Rio de Janeiro · ★4.70 · 2 bedrooms · 2 beds · 1 bath	68997	Matthias	NaN	Copacabana	-22.965990	-43.179400	Entire home/apt	279	5	301	2023-09-11	1.87	1	265	25	NaN
1	25026	Rental unit in Rio de Janeiro · ★4.71 · 1 bedroom · 1 bed · 1 bath	102840	Viviane	NaN	Copacabana	-22.977350	-43.191050	Entire home/apt	330	2	272	2023-09-07	1.68	1	203	24	NaN
2	35764	Loft in Rio de Janeiro · ★4.90 · 1 bedroom · 1 bed · 1.5 baths	153691	Patricia Miranda & Paulo	NaN	Copacabana	-22.981070	-43.191360	Entire home/apt	192	3	446	2023-09-11	2.82	1	46	37	NaN
3	48305	Rental unit in Ipanema · ★4.74 · 6 bedrooms · 7 beds · 7 baths	70933	Goitaca	NaN	Ipanema	-22.985910	-43.203020	Entire home/apt	3448	2	152	2023-09-10	0.99	9	306	30	NaN
4	48901	Rental unit in Rio · ★4.37 · 4 bedrooms · 5 beds · 3 baths	222884	Marcio	NaN	Copacabana	-22.965740	-43.175140	Entire home/apt	703	3	20	2023-09-10	0.20	1	307	12	NaN
5	49179	Rental unit in Rio de Janeiro · ★4.81 · 1 bedroom · 1 bed · 1 bath	224192	David	NaN	Copacabana	-22.979100	-43.190080	Entire home/apt	201	4	147	2023-09-05	1.12	20	159	20	NaN
6	51703	Rental unit in Rio de Janeiro · ★4.75 · Studio · 1 bed · 1 bath	238091	Dália	NaN	Copacabana	-22.981731	-43.190571	Entire home/apt	178	3	250	2023-08-28	1.85	2	321	30	NaN
7	53533	Home in Joatinga · ★4.94 · 4 bedrooms · 6 beds · 4 baths	249439	Sherri & Andre	NaN	Joá	-23.008090	-43.291130	Entire home/apt	1278	2	34	2023-07-24	0.24	1	341	8	NaN
8	60718	Rental unit in Rio de Janeiro · ★4.78 · 4 bedrooms · 4 beds · 2 baths	292870	Tânia	NaN	Flamengo	-22.929720	-43.174880	Entire home/apt	690	6	10	2023-02-27	0.06	1	328	2	NaN
9	64795	Rental unit in Rio de Janeiro · ★4.75 · 3 bedrooms · 4 beds · 2.5 baths	93005	Andrea	NaN	Ipanema	-22.981690	-43.202800	Entire home/apt	543	3	64	2023-08-15	0.42	1	156	22	NaN

	id	name	host_id	host_name	neighbourhood_group	neighbourhood	latitude	longitude	room_type	price	minimum_nights	number_of_reviews	last_review	reviews_per_month	calculated_host_listings_count	availability_365	number_of_reviews_ltm	license
490	930736	Rental unit in Rio de Janeiro · ★5.0 · 3 bedrooms · 2 beds · 2 shared baths	4710077	Gabriella	NaN	Santa Teresa	-22.915897	-43.182817	Private room	104	7	3	2023-03-01	0.19	2	59	1	NaN
491	931638	Rental unit in Rio De Janeiro · ★4.76 · 3 bedrooms · 8 beds · 2.5 baths	1982737	Estadia	NaN	Leblon	-22.981310	-43.220620	Entire home/apt	614	1	54	2023-09-18	0.42	121	131	4	NaN
492	932270	Rental unit in Rio de Janeiro · ★4.66 · Studio · 2 beds · 1 bath	5020460	Samantha	NaN	Leme	-22.963850	-43.171140	Entire home/apt	305	2	78	2022-05-24	0.64	4	97	0	NaN
493	935028	Loft in Copacabana · ★4.83 · 1 bedroom · 1 bed · 1 bath	4986394	Renata	NaN	Copacabana	-22.978222	-43.189121	Entire home/apt	336	2	218	2023-07-27	1.71	4	93	22	NaN
494	935090	Rental unit in Copacabana · ★4.79 · 1 bedroom · 2 beds · 1 bath	4986394	Renata	NaN	Copacabana	-22.975700	-43.192520	Entire home/apt	226	2	82	2023-08-28	0.67	4	174	18	NaN
495	935162	Rental unit in Rio de Janeiro · ★4.40 · 1 bedroom · 6 beds · 1 shared bath	4530533	Vanusa	NaN	Penha Circular	-22.840870	-43.297820	Private room	90	1	5	2022-09-11	0.04	3	0	0	NaN
496	937388	Rental unit in Rio de Janeiro · ★4.46 · 1 bedroom · 2 beds · 1 bath	5060612	Gabriel	NaN	Copacabana	-22.967520	-43.182430	Entire home/apt	166	4	338	2023-09-22	2.63	3	321	35	NaN
497	940749	Rental unit in Rio de Janeiro · ★4.50 · 1 bedroom · 1.5 baths	64036	Tatiana	NaN	Santa Teresa	-22.918870	-43.179810	Private room	160	5	6	2014-09-06	0.05	2	262	0	NaN
498	941735	Rental unit in Rio de Janeiro · 2 bedrooms · 2 beds · 1 bath	5092388	Anne	NaN	Tijuca	-22.920250	-43.231940	Entire home/apt	2000	1	0	None	NaN	1	365	0	NaN
499	942218	Rental unit in Rio de Janeiro · ★4.80 · 2 bedrooms · 4 beds · 2 baths	497736	Joana	NaN	Recreio dos Bandeirantes	-23.007250	-43.444380	Entire home/apt	300	2	10	2023-05-01	0.08	1	319	3	NaN

Overview

Variables

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Decimal Number

Other Punctuation

Space Separator

Other Symbol

Dash Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Misc Symbols

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Other Punctuation

Decimal Number

Space Separator

Nonspacing Mark

Other Symbol

Open Punctuation

Close Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Inherited

Most occurring blocks

Most frequent character per block

ASCII

None

VS

Dingbats

Common Values

Length

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

None

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Lowercase Letter

Uppercase Letter

Space Separator

Other Punctuation

Most occurring scripts

Most frequent character per script

Latin

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values